﻿exec sp_configure 'show advanced options', '1';
go
reconfigure;
go
exec sp_configure 'clr enabled', '1'
go
reconfigure;
go
exec sp_configure 'show advanced options', '0';
go
reconfigure;
go
/*
EXEC sp_configure 'CLR ENABLED' , '1'
GO
RECONFIGURE
GO
ALTER DATABASE [my database] SET TRUSTWORTHY ON
GO
ALTER AUTHORIZATION ON DATABASE::[my database] TO [sa];
GO
ALTER DATABASE [my database] SET ALLOW_SNAPSHOT_ISOLATION ON;
GO
ALTER DATABASE [my database] SET READ_COMMITTED_SNAPSHOT ON;
GO
*/